| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
| ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
| RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | RetailStore(PA_STR_RTL) |
| ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | Item(AS_ITM) |
| ItemSalesAmount | The monetary value of ITEMS sold during the REPORTING PERIOD | MO_SLS_ITM | Money | decimal(16,5) | |
| ItemSalesUnitCount | The number of ITEMs sold during the REPORTING PERIOD | QU_SLS_ITM | QuantityShortCount | decimal(3,0) | |
| ItemSalesTransactionCount | The number of TRANSACTIONS featuring the sale of this ITEM during the REPORTING PERIOD | QU_SLS_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemSalesCostAmount | The monetary cost value of Items sold during the ReportingPeriod. | MO_CST_ITM | MoneyShortCost | decimal(16,5) | |
| ItemReturnAmount | The monetary value of ITEMS returned during the REPORTING PERIOD | MO_RTN_ITM | Money | decimal(16,5) | |
| ItemReturnUnitCount | The number of ITEMs returned during the REPORTING PERIOD | QU_RTN_ITM | QuantityShortCount | decimal(3,0) | |
| ItemReturnTransactionCount | The number of TRANSACTIONS featuring the return of this ITEM during the REPORTING PERIOD | QU_RTN_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemDiscountAmount | The monetary value of all ordinary discounts applied to this ITEM during the REPORTING PERIOD | MO_DSC_ITM | Money | decimal(16,5) | |
| ItemDiscountUnitCount | The number of ITEMs that had an ordinary discount applied to during the REPORTING PERIOD | QU_DSC_ITM | Quantity | DECIMAL(9,3) | |
| ItemDiscountTransactionCount | The number of TRANSACTIONS featuring the application of ordinary discounts to this ITEM during the REPORTING PERIOD | QU_DSC_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemEmployeeDiscountAmount | The monetary value of all employee discounts applied to this ITEM during the REPORTING PERIOD | MO_DSC_EM_ITM | Money | decimal(16,5) | |
| ItemEmployeeDiscountUnitCount | The number of ITEMs that had an employee discount applied to during the REPORTING PERIOD | QU_DSC_EM_ITM | Quantity | DECIMAL(9,3) | |
| ItemEmployeeDiscountTransactionCount | The number of TRANSACTIONS featuring the application of employee discounts to this ITEM during the REPORTING PERIOD | QU_DSC_EM_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemStoreCouponAmount | The monetary value of all StoreCoupons presented for this ITEM during the REPORTING PERIOD | MO_CPN_STR_ITM | Money | decimal(16,5) | |
| ItemStoreCouponUnitCount | The number of ITEMs for which StoreCoupons presented during the REPORTING PERIOD | QU_CPN_STR_ITM | QuantityShortCount | decimal(3,0) | |
| ItemStoreCouponTransactionCount | The number of TRANSACTIONSs during which StoreCoupons were presented for this ITEM during the REPORTING PERIOD | QU_CPN_STR_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemStoreRefundAmount | The monetary amount of all Store Refunds applied to this ITEM during the REPORTING PERIOD | MO_RFD_STR_ITM | Money | decimal(16,5) | |
| ItemStoreRefundUnitCount | The number of store refunds that were applied to this ITEM during the REPORTING PERIOD | QU_RFD_STR_ITM | QuantityShortCount | decimal(3,0) | |
| ItemStoreRefundTransactionCount | The number of TRANSACTIONS during which store refunds were applied to this ITEM during the REPORTING PERIOD | QU_RFD_STR_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemMarkdownAmount | The total value of ITEM markdowns sold within the REPORTING PERIOD. | MO_MKD_ITM | Money | decimal(16,5) | |
| ItemMarkdownUnitCount | The total number of items marked down within the REPORTING PERIOD. | QU_MKD_ITM | QuantityShortCount | decimal(3,0) | |
| ItemMarkdownTransactionCount | The number of TRANSACTIONS during which this ITEM was marked down during the REPORTING PERIOD | QU_MKD_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemVoidAmount | The total monetary value of items voided items within the REPORTING PERIOD. | MO_VD_ITM | Money | decimal(16,5) | |
| ItemVoidUnitCount | The total number of items voided within the REPORTING PERIOD. | QU_VD_ITM | QuantityShortCount | decimal(3,0) | |
| ItemVoidTransactionCount | The number of TRANSACTIONS during which this ITEM was voided during the REPORTING PERIOD | QU_VD_TRN | QuantityTransactionCount | decimal(7,0) | |